package com.cc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.cc.confirmOrder;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Lenovo
* @description 针对表【confirm_order】的数据库操作Mapper
* @createDate 2024-11-27 20:44:50
* @Entity com.cc.domain.ConfirmOrder
*/
public interface ConfirmOrderMapper extends BaseMapper<confirmOrder> {

    @Select("select uid, sum(total_amount) num from confirm_order where uid = #{uid} and state in(2,3,4) GROUP BY uid")
    List<confirmOrder> findAll(confirmOrder confirmOrder,Integer uid);

}




